const mysql = require('mysql')

var connection = mysql.createConnection({
    host     :'39.105.103.98',
    user     :'root',
    password :'fyl123456',
    port     :'3306',
    database :'world',
});

connection.connect();

let sql = "SELECT ID,NAME FROM city WHERE COUNTRYCODE = 'NLD' GROUP BY ID;"

connection.query(sql,(err,result)=>{
    if(err){
        console.error('[SELECT ERROR] -' + err.message)
        return;
    }
    console.log('--------------------------SELECT----------------------------');
    console.log(result);
    console.log('------------------------------------------------------------\n\n');  
})

connection.end()